﻿<%@ page language="C#" masterpagefile="~/MasterPage.master" autoeventwireup="true" inherits="MyDatabase, App_Web_ni0tmiv8" title="Welcome to XPSTUDIO 我的数据库" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<div class="padding box">
        <div id="btn-create"><asp:LinkButton ID="LinkButton1" runat="server" CssClass="box"><span>新建数据库表</span></asp:LinkButton></div>
        
        </div>
        <ul class="box">
        <li><a href="#">表</a></li>
        <li><a href="#">视图</a></li>
        <li><a href="#">存储过程</a></li>
        </ul>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
<h2>Tables</h2>
<h3>UMS_Users</h3>
<table>
<tr><th>序号</th><th>字段名</th><th>字段类型</th><th>长度</th><th>主键</th><th>外键</th><th>空值</th><th>字段说明</th></tr>
<tr><td align="center">1</td><td>UserID</td><td>int</td><td>4</td><td>√</td><td>&nbsp;</td><td>×</td><td>用户ID，唯一标识符</td></tr>
<tr class="bg"><td align="center">2</td><td>UserName</td><td>nvarchar</td><td>50</td><td>&nbsp;</td><td>&nbsp;</td><td>×</td><td>用户名，唯一标识</td></tr>
<tr><td align="center">3</td><td>Password</td><td>nvarchar</td><td>长度</td><td>&nbsp;</td><td>&nbsp;</td><td>×</td><td>用户密码</td></tr>
<tr class="bg"><td align="center">4</td><td>PasswordFormat</td><td>int</td><td>4</td><td>&nbsp;</td><td>&nbsp;</td><td>×</td><td>密码格式 0明文 1MD5 2SHA1</td></tr>
<tr><td align="center">5</td><td>Salt</td><td>nvarchar</td><td>10</td><td>&nbsp;</td><td>&nbsp;</td><td>空值</td><td>密码随机值</td></tr>
<tr class="bg"><td align="center">6</td><td>DateCreated</td><td>datetime</td><td>8</td><td>&nbsp;</td><td>&nbsp;</td><td>空值</td><td>创建日期</td></tr>
<tr><td align="center">7</td><td>Gender</td><td>int</td><td>4</td><td>&nbsp;</td><td>&nbsp;</td><td>√</td><td>用户性别</td></tr>
<tr class="bg"><td align="center">8</td><td>Email</td><td>nvarchar</td><td>100</td><td>&nbsp;</td><td>&nbsp;</td><td>√</td><td>用户EMAIL</td></tr>
</table>
</asp:Content>

